from flask import Blueprint

bp_course = Blueprint('course',__name__)
    
#接口
@bp_course.route('/couponM',methods=['POST',"GET"])
def couponM():
    #添加
    if request.method == "POST":
        #获取用户输入
        data = request.data
        if data:
            data = json.loads(data)
        else:
            data = request.form
        #构造sql语句
        sql = "insert into coupon values(0,'%s',%d,'%s','%s')"%(data['name'],int(data['total']),data['stime'],data['etime'])
        #pymysql
        db1.insert(sql)
        #返回结果
        return 'ok'
    else:
        id = request.args.get('id')
        sql = 'select * from coupon where id=%d'%(int(id))
        res = db1.find(sql)







    elif request.method == 'PUT':
                data = request.data
            if data:
                data = json.loads(data)
            else:
                data = request.form
                sql = "update coupon set name='%s',total=%d,starttime='%s',endtime='%s' where id=%d"%(data['name',int(data['total']),data['stime'],data['etime'],int(data['id'])])
                db1.insert(sql)
                return jsonify({'code':200})
            elif request.method == "DELETE":
                    id = request.args.get('id')
                    sql = 'delete from coupon where id=%d'%(int(id))
                    db1.insert(sql)
                    returun jsonify({"code:200"})